package com.kingzoon.seckill.entity;

import java.util.ArrayList;
import java.util.List;

public class UaCompanyInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    public UaCompanyInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andExchangeIdIsNull() {
            addCriterion("EXCHANGE_ID is null");
            return (Criteria) this;
        }

        public Criteria andExchangeIdIsNotNull() {
            addCriterion("EXCHANGE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeIdEqualTo(String value) {
            addCriterion("EXCHANGE_ID =", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotEqualTo(String value) {
            addCriterion("EXCHANGE_ID <>", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdGreaterThan(String value) {
            addCriterion("EXCHANGE_ID >", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdGreaterThanOrEqualTo(String value) {
            addCriterion("EXCHANGE_ID >=", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLessThan(String value) {
            addCriterion("EXCHANGE_ID <", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLessThanOrEqualTo(String value) {
            addCriterion("EXCHANGE_ID <=", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLike(String value) {
            addCriterion("EXCHANGE_ID like", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotLike(String value) {
            addCriterion("EXCHANGE_ID not like", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdIn(List<String> values) {
            addCriterion("EXCHANGE_ID in", values, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotIn(List<String> values) {
            addCriterion("EXCHANGE_ID not in", values, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdBetween(String value1, String value2) {
            addCriterion("EXCHANGE_ID between", value1, value2, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotBetween(String value1, String value2) {
            addCriterion("EXCHANGE_ID not between", value1, value2, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIsNull() {
            addCriterion("DISTRIBUTOR_ID is null");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIsNotNull() {
            addCriterion("DISTRIBUTOR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDistributorIdEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID =", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID <>", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdGreaterThan(String value) {
            addCriterion("DISTRIBUTOR_ID >", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdGreaterThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID >=", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLessThan(String value) {
            addCriterion("DISTRIBUTOR_ID <", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLessThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID <=", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLike(String value) {
            addCriterion("DISTRIBUTOR_ID like", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotLike(String value) {
            addCriterion("DISTRIBUTOR_ID not like", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIn(List<String> values) {
            addCriterion("DISTRIBUTOR_ID in", values, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotIn(List<String> values) {
            addCriterion("DISTRIBUTOR_ID not in", values, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdBetween(String value1, String value2) {
            addCriterion("DISTRIBUTOR_ID between", value1, value2, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotBetween(String value1, String value2) {
            addCriterion("DISTRIBUTOR_ID not between", value1, value2, "distributorId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("MEMBER_ID is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("MEMBER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(String value) {
            addCriterion("MEMBER_ID =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(String value) {
            addCriterion("MEMBER_ID <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(String value) {
            addCriterion("MEMBER_ID >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_ID >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(String value) {
            addCriterion("MEMBER_ID <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_ID <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLike(String value) {
            addCriterion("MEMBER_ID like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotLike(String value) {
            addCriterion("MEMBER_ID not like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<String> values) {
            addCriterion("MEMBER_ID in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<String> values) {
            addCriterion("MEMBER_ID not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(String value1, String value2) {
            addCriterion("MEMBER_ID between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(String value1, String value2) {
            addCriterion("MEMBER_ID not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameIsNull() {
            addCriterion("ORG_CN_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameIsNotNull() {
            addCriterion("ORG_CN_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameEqualTo(String value) {
            addCriterion("ORG_CN_NAME =", value, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameNotEqualTo(String value) {
            addCriterion("ORG_CN_NAME <>", value, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameGreaterThan(String value) {
            addCriterion("ORG_CN_NAME >", value, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CN_NAME >=", value, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameLessThan(String value) {
            addCriterion("ORG_CN_NAME <", value, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameLessThanOrEqualTo(String value) {
            addCriterion("ORG_CN_NAME <=", value, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameLike(String value) {
            addCriterion("ORG_CN_NAME like", value, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameNotLike(String value) {
            addCriterion("ORG_CN_NAME not like", value, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameIn(List<String> values) {
            addCriterion("ORG_CN_NAME in", values, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameNotIn(List<String> values) {
            addCriterion("ORG_CN_NAME not in", values, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameBetween(String value1, String value2) {
            addCriterion("ORG_CN_NAME between", value1, value2, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnNameNotBetween(String value1, String value2) {
            addCriterion("ORG_CN_NAME not between", value1, value2, "orgCnName");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortIsNull() {
            addCriterion("ORG_CN_SHORT is null");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortIsNotNull() {
            addCriterion("ORG_CN_SHORT is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortEqualTo(String value) {
            addCriterion("ORG_CN_SHORT =", value, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortNotEqualTo(String value) {
            addCriterion("ORG_CN_SHORT <>", value, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortGreaterThan(String value) {
            addCriterion("ORG_CN_SHORT >", value, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CN_SHORT >=", value, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortLessThan(String value) {
            addCriterion("ORG_CN_SHORT <", value, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortLessThanOrEqualTo(String value) {
            addCriterion("ORG_CN_SHORT <=", value, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortLike(String value) {
            addCriterion("ORG_CN_SHORT like", value, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortNotLike(String value) {
            addCriterion("ORG_CN_SHORT not like", value, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortIn(List<String> values) {
            addCriterion("ORG_CN_SHORT in", values, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortNotIn(List<String> values) {
            addCriterion("ORG_CN_SHORT not in", values, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortBetween(String value1, String value2) {
            addCriterion("ORG_CN_SHORT between", value1, value2, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgCnShortNotBetween(String value1, String value2) {
            addCriterion("ORG_CN_SHORT not between", value1, value2, "orgCnShort");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameIsNull() {
            addCriterion("ORG_EN_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameIsNotNull() {
            addCriterion("ORG_EN_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameEqualTo(String value) {
            addCriterion("ORG_EN_NAME =", value, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameNotEqualTo(String value) {
            addCriterion("ORG_EN_NAME <>", value, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameGreaterThan(String value) {
            addCriterion("ORG_EN_NAME >", value, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_EN_NAME >=", value, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameLessThan(String value) {
            addCriterion("ORG_EN_NAME <", value, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameLessThanOrEqualTo(String value) {
            addCriterion("ORG_EN_NAME <=", value, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameLike(String value) {
            addCriterion("ORG_EN_NAME like", value, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameNotLike(String value) {
            addCriterion("ORG_EN_NAME not like", value, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameIn(List<String> values) {
            addCriterion("ORG_EN_NAME in", values, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameNotIn(List<String> values) {
            addCriterion("ORG_EN_NAME not in", values, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameBetween(String value1, String value2) {
            addCriterion("ORG_EN_NAME between", value1, value2, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgEnNameNotBetween(String value1, String value2) {
            addCriterion("ORG_EN_NAME not between", value1, value2, "orgEnName");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNull() {
            addCriterion("ORG_CODE is null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNotNull() {
            addCriterion("ORG_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeEqualTo(String value) {
            addCriterion("ORG_CODE =", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotEqualTo(String value) {
            addCriterion("ORG_CODE <>", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThan(String value) {
            addCriterion("ORG_CODE >", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CODE >=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThan(String value) {
            addCriterion("ORG_CODE <", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThanOrEqualTo(String value) {
            addCriterion("ORG_CODE <=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLike(String value) {
            addCriterion("ORG_CODE like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotLike(String value) {
            addCriterion("ORG_CODE not like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIn(List<String> values) {
            addCriterion("ORG_CODE in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotIn(List<String> values) {
            addCriterion("ORG_CODE not in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeBetween(String value1, String value2) {
            addCriterion("ORG_CODE between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotBetween(String value1, String value2) {
            addCriterion("ORG_CODE not between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateIsNull() {
            addCriterion("ORG_CODE_AVALIDATE is null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateIsNotNull() {
            addCriterion("ORG_CODE_AVALIDATE is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateEqualTo(Long value) {
            addCriterion("ORG_CODE_AVALIDATE =", value, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateNotEqualTo(Long value) {
            addCriterion("ORG_CODE_AVALIDATE <>", value, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateGreaterThan(Long value) {
            addCriterion("ORG_CODE_AVALIDATE >", value, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateGreaterThanOrEqualTo(Long value) {
            addCriterion("ORG_CODE_AVALIDATE >=", value, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateLessThan(Long value) {
            addCriterion("ORG_CODE_AVALIDATE <", value, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateLessThanOrEqualTo(Long value) {
            addCriterion("ORG_CODE_AVALIDATE <=", value, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateIn(List<Long> values) {
            addCriterion("ORG_CODE_AVALIDATE in", values, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateNotIn(List<Long> values) {
            addCriterion("ORG_CODE_AVALIDATE not in", values, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateBetween(Long value1, Long value2) {
            addCriterion("ORG_CODE_AVALIDATE between", value1, value2, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andOrgCodeAvalidateNotBetween(Long value1, Long value2) {
            addCriterion("ORG_CODE_AVALIDATE not between", value1, value2, "orgCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeIsNull() {
            addCriterion("SOCIAL_CREDIT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeIsNotNull() {
            addCriterion("SOCIAL_CREDIT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeEqualTo(String value) {
            addCriterion("SOCIAL_CREDIT_CODE =", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeNotEqualTo(String value) {
            addCriterion("SOCIAL_CREDIT_CODE <>", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeGreaterThan(String value) {
            addCriterion("SOCIAL_CREDIT_CODE >", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeGreaterThanOrEqualTo(String value) {
            addCriterion("SOCIAL_CREDIT_CODE >=", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeLessThan(String value) {
            addCriterion("SOCIAL_CREDIT_CODE <", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeLessThanOrEqualTo(String value) {
            addCriterion("SOCIAL_CREDIT_CODE <=", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeLike(String value) {
            addCriterion("SOCIAL_CREDIT_CODE like", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeNotLike(String value) {
            addCriterion("SOCIAL_CREDIT_CODE not like", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeIn(List<String> values) {
            addCriterion("SOCIAL_CREDIT_CODE in", values, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeNotIn(List<String> values) {
            addCriterion("SOCIAL_CREDIT_CODE not in", values, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeBetween(String value1, String value2) {
            addCriterion("SOCIAL_CREDIT_CODE between", value1, value2, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeNotBetween(String value1, String value2) {
            addCriterion("SOCIAL_CREDIT_CODE not between", value1, value2, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateIsNull() {
            addCriterion("CREDIT_CODE_AVALIDATE is null");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateIsNotNull() {
            addCriterion("CREDIT_CODE_AVALIDATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateEqualTo(Long value) {
            addCriterion("CREDIT_CODE_AVALIDATE =", value, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateNotEqualTo(Long value) {
            addCriterion("CREDIT_CODE_AVALIDATE <>", value, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateGreaterThan(Long value) {
            addCriterion("CREDIT_CODE_AVALIDATE >", value, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateGreaterThanOrEqualTo(Long value) {
            addCriterion("CREDIT_CODE_AVALIDATE >=", value, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateLessThan(Long value) {
            addCriterion("CREDIT_CODE_AVALIDATE <", value, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateLessThanOrEqualTo(Long value) {
            addCriterion("CREDIT_CODE_AVALIDATE <=", value, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateIn(List<Long> values) {
            addCriterion("CREDIT_CODE_AVALIDATE in", values, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateNotIn(List<Long> values) {
            addCriterion("CREDIT_CODE_AVALIDATE not in", values, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateBetween(Long value1, Long value2) {
            addCriterion("CREDIT_CODE_AVALIDATE between", value1, value2, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andCreditCodeAvalidateNotBetween(Long value1, Long value2) {
            addCriterion("CREDIT_CODE_AVALIDATE not between", value1, value2, "creditCodeAvalidate");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseIsNull() {
            addCriterion("BUSINESS_LICENSE is null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseIsNotNull() {
            addCriterion("BUSINESS_LICENSE is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseEqualTo(String value) {
            addCriterion("BUSINESS_LICENSE =", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNotEqualTo(String value) {
            addCriterion("BUSINESS_LICENSE <>", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseGreaterThan(String value) {
            addCriterion("BUSINESS_LICENSE >", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseGreaterThanOrEqualTo(String value) {
            addCriterion("BUSINESS_LICENSE >=", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseLessThan(String value) {
            addCriterion("BUSINESS_LICENSE <", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseLessThanOrEqualTo(String value) {
            addCriterion("BUSINESS_LICENSE <=", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseLike(String value) {
            addCriterion("BUSINESS_LICENSE like", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNotLike(String value) {
            addCriterion("BUSINESS_LICENSE not like", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseIn(List<String> values) {
            addCriterion("BUSINESS_LICENSE in", values, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNotIn(List<String> values) {
            addCriterion("BUSINESS_LICENSE not in", values, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseBetween(String value1, String value2) {
            addCriterion("BUSINESS_LICENSE between", value1, value2, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNotBetween(String value1, String value2) {
            addCriterion("BUSINESS_LICENSE not between", value1, value2, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateIsNull() {
            addCriterion("REGSITER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateIsNotNull() {
            addCriterion("REGSITER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateEqualTo(Long value) {
            addCriterion("REGSITER_DATE =", value, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateNotEqualTo(Long value) {
            addCriterion("REGSITER_DATE <>", value, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateGreaterThan(Long value) {
            addCriterion("REGSITER_DATE >", value, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateGreaterThanOrEqualTo(Long value) {
            addCriterion("REGSITER_DATE >=", value, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateLessThan(Long value) {
            addCriterion("REGSITER_DATE <", value, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateLessThanOrEqualTo(Long value) {
            addCriterion("REGSITER_DATE <=", value, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateIn(List<Long> values) {
            addCriterion("REGSITER_DATE in", values, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateNotIn(List<Long> values) {
            addCriterion("REGSITER_DATE not in", values, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateBetween(Long value1, Long value2) {
            addCriterion("REGSITER_DATE between", value1, value2, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andRegsiterDateNotBetween(Long value1, Long value2) {
            addCriterion("REGSITER_DATE not between", value1, value2, "regsiterDate");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIsNull() {
            addCriterion("LEGAL_PERSON is null");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIsNotNull() {
            addCriterion("LEGAL_PERSON is not null");
            return (Criteria) this;
        }

        public Criteria andLegalPersonEqualTo(String value) {
            addCriterion("LEGAL_PERSON =", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonNotEqualTo(String value) {
            addCriterion("LEGAL_PERSON <>", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonGreaterThan(String value) {
            addCriterion("LEGAL_PERSON >", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonGreaterThanOrEqualTo(String value) {
            addCriterion("LEGAL_PERSON >=", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonLessThan(String value) {
            addCriterion("LEGAL_PERSON <", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonLessThanOrEqualTo(String value) {
            addCriterion("LEGAL_PERSON <=", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonLike(String value) {
            addCriterion("LEGAL_PERSON like", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonNotLike(String value) {
            addCriterion("LEGAL_PERSON not like", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIn(List<String> values) {
            addCriterion("LEGAL_PERSON in", values, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonNotIn(List<String> values) {
            addCriterion("LEGAL_PERSON not in", values, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonBetween(String value1, String value2) {
            addCriterion("LEGAL_PERSON between", value1, value2, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonNotBetween(String value1, String value2) {
            addCriterion("LEGAL_PERSON not between", value1, value2, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeIsNull() {
            addCriterion("LEGAL_ID_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeIsNotNull() {
            addCriterion("LEGAL_ID_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeEqualTo(String value) {
            addCriterion("LEGAL_ID_TYPE =", value, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeNotEqualTo(String value) {
            addCriterion("LEGAL_ID_TYPE <>", value, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeGreaterThan(String value) {
            addCriterion("LEGAL_ID_TYPE >", value, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeGreaterThanOrEqualTo(String value) {
            addCriterion("LEGAL_ID_TYPE >=", value, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeLessThan(String value) {
            addCriterion("LEGAL_ID_TYPE <", value, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeLessThanOrEqualTo(String value) {
            addCriterion("LEGAL_ID_TYPE <=", value, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeLike(String value) {
            addCriterion("LEGAL_ID_TYPE like", value, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeNotLike(String value) {
            addCriterion("LEGAL_ID_TYPE not like", value, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeIn(List<String> values) {
            addCriterion("LEGAL_ID_TYPE in", values, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeNotIn(List<String> values) {
            addCriterion("LEGAL_ID_TYPE not in", values, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeBetween(String value1, String value2) {
            addCriterion("LEGAL_ID_TYPE between", value1, value2, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdTypeNotBetween(String value1, String value2) {
            addCriterion("LEGAL_ID_TYPE not between", value1, value2, "legalIdType");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeIsNull() {
            addCriterion("LEGAL_ID_CODE is null");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeIsNotNull() {
            addCriterion("LEGAL_ID_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeEqualTo(String value) {
            addCriterion("LEGAL_ID_CODE =", value, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeNotEqualTo(String value) {
            addCriterion("LEGAL_ID_CODE <>", value, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeGreaterThan(String value) {
            addCriterion("LEGAL_ID_CODE >", value, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeGreaterThanOrEqualTo(String value) {
            addCriterion("LEGAL_ID_CODE >=", value, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeLessThan(String value) {
            addCriterion("LEGAL_ID_CODE <", value, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeLessThanOrEqualTo(String value) {
            addCriterion("LEGAL_ID_CODE <=", value, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeLike(String value) {
            addCriterion("LEGAL_ID_CODE like", value, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeNotLike(String value) {
            addCriterion("LEGAL_ID_CODE not like", value, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeIn(List<String> values) {
            addCriterion("LEGAL_ID_CODE in", values, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeNotIn(List<String> values) {
            addCriterion("LEGAL_ID_CODE not in", values, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeBetween(String value1, String value2) {
            addCriterion("LEGAL_ID_CODE between", value1, value2, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andLegalIdCodeNotBetween(String value1, String value2) {
            addCriterion("LEGAL_ID_CODE not between", value1, value2, "legalIdCode");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressIsNull() {
            addCriterion("ORG_REG_ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressIsNotNull() {
            addCriterion("ORG_REG_ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressEqualTo(String value) {
            addCriterion("ORG_REG_ADDRESS =", value, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressNotEqualTo(String value) {
            addCriterion("ORG_REG_ADDRESS <>", value, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressGreaterThan(String value) {
            addCriterion("ORG_REG_ADDRESS >", value, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_REG_ADDRESS >=", value, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressLessThan(String value) {
            addCriterion("ORG_REG_ADDRESS <", value, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressLessThanOrEqualTo(String value) {
            addCriterion("ORG_REG_ADDRESS <=", value, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressLike(String value) {
            addCriterion("ORG_REG_ADDRESS like", value, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressNotLike(String value) {
            addCriterion("ORG_REG_ADDRESS not like", value, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressIn(List<String> values) {
            addCriterion("ORG_REG_ADDRESS in", values, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressNotIn(List<String> values) {
            addCriterion("ORG_REG_ADDRESS not in", values, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressBetween(String value1, String value2) {
            addCriterion("ORG_REG_ADDRESS between", value1, value2, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andOrgRegAddressNotBetween(String value1, String value2) {
            addCriterion("ORG_REG_ADDRESS not between", value1, value2, "orgRegAddress");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("PHONE is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("PHONE is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("PHONE =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("PHONE <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("PHONE >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("PHONE >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("PHONE <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("PHONE <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("PHONE like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("PHONE not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("PHONE in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("PHONE not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("PHONE between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("PHONE not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("MOBILE is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("MOBILE is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("MOBILE =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("MOBILE <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("MOBILE >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("MOBILE <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("MOBILE <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("MOBILE like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("MOBILE not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("MOBILE in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("MOBILE not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("MOBILE between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("MOBILE not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andCountryIsNull() {
            addCriterion("COUNTRY is null");
            return (Criteria) this;
        }

        public Criteria andCountryIsNotNull() {
            addCriterion("COUNTRY is not null");
            return (Criteria) this;
        }

        public Criteria andCountryEqualTo(String value) {
            addCriterion("COUNTRY =", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotEqualTo(String value) {
            addCriterion("COUNTRY <>", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThan(String value) {
            addCriterion("COUNTRY >", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThanOrEqualTo(String value) {
            addCriterion("COUNTRY >=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThan(String value) {
            addCriterion("COUNTRY <", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThanOrEqualTo(String value) {
            addCriterion("COUNTRY <=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLike(String value) {
            addCriterion("COUNTRY like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotLike(String value) {
            addCriterion("COUNTRY not like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryIn(List<String> values) {
            addCriterion("COUNTRY in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotIn(List<String> values) {
            addCriterion("COUNTRY not in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryBetween(String value1, String value2) {
            addCriterion("COUNTRY between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotBetween(String value1, String value2) {
            addCriterion("COUNTRY not between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("PROVINCE is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("PROVINCE is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("PROVINCE =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("PROVINCE <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("PROVINCE >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("PROVINCE >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("PROVINCE <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("PROVINCE <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("PROVINCE like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("PROVINCE not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("PROVINCE in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("PROVINCE not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("PROVINCE between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("PROVINCE not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("CITY is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("CITY is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("CITY =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("CITY <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("CITY >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("CITY >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("CITY <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("CITY <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("CITY like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("CITY not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("CITY in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("CITY not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("CITY between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("CITY not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andActorNameIsNull() {
            addCriterion("ACTOR_NAME is null");
            return (Criteria) this;
        }

        public Criteria andActorNameIsNotNull() {
            addCriterion("ACTOR_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andActorNameEqualTo(String value) {
            addCriterion("ACTOR_NAME =", value, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameNotEqualTo(String value) {
            addCriterion("ACTOR_NAME <>", value, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameGreaterThan(String value) {
            addCriterion("ACTOR_NAME >", value, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameGreaterThanOrEqualTo(String value) {
            addCriterion("ACTOR_NAME >=", value, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameLessThan(String value) {
            addCriterion("ACTOR_NAME <", value, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameLessThanOrEqualTo(String value) {
            addCriterion("ACTOR_NAME <=", value, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameLike(String value) {
            addCriterion("ACTOR_NAME like", value, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameNotLike(String value) {
            addCriterion("ACTOR_NAME not like", value, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameIn(List<String> values) {
            addCriterion("ACTOR_NAME in", values, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameNotIn(List<String> values) {
            addCriterion("ACTOR_NAME not in", values, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameBetween(String value1, String value2) {
            addCriterion("ACTOR_NAME between", value1, value2, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorNameNotBetween(String value1, String value2) {
            addCriterion("ACTOR_NAME not between", value1, value2, "actorName");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeIsNull() {
            addCriterion("ACTOR_ID_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeIsNotNull() {
            addCriterion("ACTOR_ID_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeEqualTo(String value) {
            addCriterion("ACTOR_ID_TYPE =", value, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeNotEqualTo(String value) {
            addCriterion("ACTOR_ID_TYPE <>", value, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeGreaterThan(String value) {
            addCriterion("ACTOR_ID_TYPE >", value, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeGreaterThanOrEqualTo(String value) {
            addCriterion("ACTOR_ID_TYPE >=", value, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeLessThan(String value) {
            addCriterion("ACTOR_ID_TYPE <", value, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeLessThanOrEqualTo(String value) {
            addCriterion("ACTOR_ID_TYPE <=", value, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeLike(String value) {
            addCriterion("ACTOR_ID_TYPE like", value, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeNotLike(String value) {
            addCriterion("ACTOR_ID_TYPE not like", value, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeIn(List<String> values) {
            addCriterion("ACTOR_ID_TYPE in", values, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeNotIn(List<String> values) {
            addCriterion("ACTOR_ID_TYPE not in", values, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeBetween(String value1, String value2) {
            addCriterion("ACTOR_ID_TYPE between", value1, value2, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdTypeNotBetween(String value1, String value2) {
            addCriterion("ACTOR_ID_TYPE not between", value1, value2, "actorIdType");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeIsNull() {
            addCriterion("ACTOR_ID_CODE is null");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeIsNotNull() {
            addCriterion("ACTOR_ID_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeEqualTo(String value) {
            addCriterion("ACTOR_ID_CODE =", value, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeNotEqualTo(String value) {
            addCriterion("ACTOR_ID_CODE <>", value, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeGreaterThan(String value) {
            addCriterion("ACTOR_ID_CODE >", value, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ACTOR_ID_CODE >=", value, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeLessThan(String value) {
            addCriterion("ACTOR_ID_CODE <", value, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeLessThanOrEqualTo(String value) {
            addCriterion("ACTOR_ID_CODE <=", value, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeLike(String value) {
            addCriterion("ACTOR_ID_CODE like", value, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeNotLike(String value) {
            addCriterion("ACTOR_ID_CODE not like", value, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeIn(List<String> values) {
            addCriterion("ACTOR_ID_CODE in", values, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeNotIn(List<String> values) {
            addCriterion("ACTOR_ID_CODE not in", values, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeBetween(String value1, String value2) {
            addCriterion("ACTOR_ID_CODE between", value1, value2, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andActorIdCodeNotBetween(String value1, String value2) {
            addCriterion("ACTOR_ID_CODE not between", value1, value2, "actorIdCode");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(String value) {
            addCriterion("BANK_NAME =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(String value) {
            addCriterion("BANK_NAME <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(String value) {
            addCriterion("BANK_NAME >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_NAME >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(String value) {
            addCriterion("BANK_NAME <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(String value) {
            addCriterion("BANK_NAME <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLike(String value) {
            addCriterion("BANK_NAME like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotLike(String value) {
            addCriterion("BANK_NAME not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<String> values) {
            addCriterion("BANK_NAME in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<String> values) {
            addCriterion("BANK_NAME not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(String value1, String value2) {
            addCriterion("BANK_NAME between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(String value1, String value2) {
            addCriterion("BANK_NAME not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andActorMobileIsNull() {
            addCriterion("ACTOR_MOBILE is null");
            return (Criteria) this;
        }

        public Criteria andActorMobileIsNotNull() {
            addCriterion("ACTOR_MOBILE is not null");
            return (Criteria) this;
        }

        public Criteria andActorMobileEqualTo(String value) {
            addCriterion("ACTOR_MOBILE =", value, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileNotEqualTo(String value) {
            addCriterion("ACTOR_MOBILE <>", value, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileGreaterThan(String value) {
            addCriterion("ACTOR_MOBILE >", value, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileGreaterThanOrEqualTo(String value) {
            addCriterion("ACTOR_MOBILE >=", value, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileLessThan(String value) {
            addCriterion("ACTOR_MOBILE <", value, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileLessThanOrEqualTo(String value) {
            addCriterion("ACTOR_MOBILE <=", value, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileLike(String value) {
            addCriterion("ACTOR_MOBILE like", value, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileNotLike(String value) {
            addCriterion("ACTOR_MOBILE not like", value, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileIn(List<String> values) {
            addCriterion("ACTOR_MOBILE in", values, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileNotIn(List<String> values) {
            addCriterion("ACTOR_MOBILE not in", values, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileBetween(String value1, String value2) {
            addCriterion("ACTOR_MOBILE between", value1, value2, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andActorMobileNotBetween(String value1, String value2) {
            addCriterion("ACTOR_MOBILE not between", value1, value2, "actorMobile");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIsNull() {
            addCriterion("BROKER_ID is null");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIsNotNull() {
            addCriterion("BROKER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBrokerIdEqualTo(String value) {
            addCriterion("BROKER_ID =", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotEqualTo(String value) {
            addCriterion("BROKER_ID <>", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdGreaterThan(String value) {
            addCriterion("BROKER_ID >", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdGreaterThanOrEqualTo(String value) {
            addCriterion("BROKER_ID >=", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLessThan(String value) {
            addCriterion("BROKER_ID <", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLessThanOrEqualTo(String value) {
            addCriterion("BROKER_ID <=", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLike(String value) {
            addCriterion("BROKER_ID like", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotLike(String value) {
            addCriterion("BROKER_ID not like", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIn(List<String> values) {
            addCriterion("BROKER_ID in", values, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotIn(List<String> values) {
            addCriterion("BROKER_ID not in", values, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdBetween(String value1, String value2) {
            addCriterion("BROKER_ID between", value1, value2, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotBetween(String value1, String value2) {
            addCriterion("BROKER_ID not between", value1, value2, "brokerId");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}